# name : import from excel (no format)
# key : import.excel
# contributor: Shuguang Sun
# --
filename ${1:infname} '${2:fname}';
%let __omsglevel__=%sysfunc(getoption(msglevel));
options msglevel=i;
proc import out=${3:dout} datafile=$1 dbms=excel replace;
  sheet=$0; /* range="dosing record$"; */
  getnames=yes; /* dbdsopts='firstobs=2'; */
  datarow=2;
  mixed=yes;  /* guessingrows = 32767; */
  scantext=yes;
  usedate=yes;
  scantime=yes;
run;
options msglevel=__omsglevel__;
filename $1 clear;